Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
Yes |
Comment |
ID pacjenta |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(1) |
Mandatory |
No |
Comment |
PL: Plec |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(60) |
Mandatory |
No |
Comment |
PL: Imie |
Name |
|
Code |
|
Data Type |
VARCHAR2(60) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(60) |
Mandatory |
No |
Comment |
PL: Nazwisko |
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(96) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
PL: Imie ojca |
Name |
|
Code |
|
Data Type |
VARCHAR2(8) |
Mandatory |
No |
Comment |
PL: Inicjaly |
Name |
|
Code |
|
Data Type |
VARCHAR2(24) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
PL: Tytul |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(48) |
Mandatory |
No |
Comment |
PL: Miejsce urodzenia |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(5) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(24) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(48) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(128) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(5) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Data ostatniej modyfikacji |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(15) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
NUMBER(5) |
Mandatory |
No |
Comment |
Kolumna jest odpowiedzialna za przetrzymywanie flagi 'Zakaz informowania o |
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
|
Name |
|
Code |
|
Data Type |
VARCHAR2(32) |
Mandatory |
No |
Comment |
Zródlo danych na potrzeby raportów do audytu danych osobowych. |
Name |
|
Code |
|
Data Type |
BLOB |
Mandatory |
No |
Comment |
Zdjecie osoby |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Informacja czy pacjent zmarl |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Wskazuje lokalnego ubezpieczyciela pacjenta, na podstawie jego adresu |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Czy dodany pacjent zostal dodany jako 'Pacjent NN' czyli pacjent o nieznanej tozsamosci. |
Name |
|
Code |
|
Data Type |
VARCHAR2(8) |
Mandatory |
No |
Comment |
Seria dokumentu tozsamosci |
Name |
|
Code |
|
Data Type |
DATE |
Mandatory |
No |
Comment |
Data wydania dokumentu tozsamosci |
Name |
|
Code |
|
Data Type |
VARCHAR2(24) |
Mandatory |
No |
Comment |
Telefon do pracodawcy |
Name |
|
Code |
|
Data Type |
VARCHAR2(255) |
Mandatory |
No |
Comment |
Osoba wystawiajaca dokument tozsamosci |
Name |
|
Code |
|
Data Type |
NUMBER(1) |
Mandatory |
Yes |
Comment |
Czy osoba jest uchodzca |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
FK Country.CountryID Id kraju pochodzenia |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Id kraju wystawiajacego dokument. |
Name |
|
Code |
|
Data Type |
<Undefined> |
Mandatory |
No |
Comment |
Imiona rodziców - kolumna wyliczalna as FatherName||' '||MotherName |
Name |
|
Code |
|
Data Type |
VARCHAR2(60) |
Mandatory |
No |
Comment |
kolumna wspomaga wyszukiwanie po drugim czlonie nazwiska |
Name |
|
Code |
|
Data Type |
VARCHAR2(24) |
Mandatory |
No |
Comment |
Identyfikator krajowy hl7Cda |
Name |
|
Code |
|
Data Type |
NUMBER(10) |
Mandatory |
No |
Comment |
Kraj wydania identyfikatora |
Name |
Code |
Primary |
X |
Name |
|
Code |
|
Primary |
Yes |
Comment |
|
|
|
|